Within the spreadsheet I used a variety of functions such as COUNTIF and VLOOKUP. The spreadsheet was for a local football club managing season ticket information and the season ticket holders. Here is he final spreadsheet I have created fully functional!